Importing text files | CSE 148 – Excel Exam 1

Importing text files explained

Say you're planning a vacation with some friends for your senior year, and are leading the charge planning this trip of a lifetime.

You found a great vacation site to do some research. It's a little sketch, but is giving you some great information, tips, and pricing information. They offer the ability to download their vacation info, only hitch is... the file type for download was a text file.

Before diving into this example, let's understand why someone may transfer Excel information via a text file instead of a massive Excel sheet.

Sometimes, people work with massive, 1000+ row Excel files that take up too much space. Transferring these databases as a text file(s) reduces file size.

When dealing with text files, the primary thing you need to take note of is:

Determine whether or not the values in the text file are separated by tabs, colons, semicolons, spaces, commas, or other characters. This is referred to as the delimiter of the text file.

Oftentimes, you'll deal with values being separated by tabs or commas, but it's important to be ready for anything.

PAID CONTENT

This is the end of the preview. To unlock the rest, get the Excel Cram Kit (Exam 1) or Lifetime Access.

Already purchased? Click here to log in.

Leave a Comment