• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 54
  • Last Modified:

I need to take this file Excel file in CSV and shrink it if possible. Is there another file format that can make this smaller?

The attached file was converted from an Excel format to a CSV file and saved. It is comma delimited and it is about 14. mb If I could shrink it down to 4 mb that would be perfect. Is there another tool that will allow me to get the file attached down to that size. (4MB or less?) I am hoping there is another tool that might shrink it down. I assume some of that size is caused by Excel itself even though it is a CSV. Any help is appreciated. Thank you.
SF_RecordTestTasksCSV.csv
0
Fletcher Burdine
Asked:
Fletcher Burdine
  • 2
  • 2
3 Solutions
 
Wayne Taylor (webtubbs)Commented:
A CSV file is just a text file, with each row's values separated by commas (Comma Separated Values). The only way to "shrink" a text file is to ZIP it.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
I have to do an import on the file and it is too large for the test environment. So I wondered if Excel might be adding some extra fluff on to the file size to make it larger. Did not know if moving it to Notepad or something like that might make it smaller? I guess that is my only solution?
0
 
Wayne Taylor (webtubbs)Commented:
As I mentioned, CSV files are text files. There is no "fluff" in them. You can check for yourself by opening the csv file in notepad.

Your only other option is to reduce the data in Excel before creating the csv file.
0
 
AlanConsultantCommented:
Hi,

As noted above, a CSV file is nothing more than a txt file with a specific format (commas used to separate fields etc).

If it is too large for your test environment, then these are the options I can think of:

1) Reduce the size of the text data CSV file (fewer records for example).

2) Increase the capacity of the test environment - Excel will import much larger files than this, so I am guessing it is a hardware / VM limitation perhaps?

3) Test outside of your test environment (take care of course, and if your test environment reflects the production environment, then you will have to either upgrade production or reduce the data file size to go to production anyway).


Hope that helps,

Alan.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Thank you both very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now