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
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RUA Volunteer2?Tableau 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
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Thank you both very much
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.