+ Reply to Thread
Results 1 to 5 of 5

Editing a VERY VERY large CSV file

  1. #1
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Editing a VERY VERY large CSV file

    Good afternoon all

    Does anyone know of a program other than Notepad to edit a CSV file with 200mil lines of data.

    Many Thanks in advance

    Peter
    One I have learnt over the last few months, " You are NEVER too old to learn ".
    Sometimes I forget to say " Thank You " for your assistance, so here I say " A BIG Thank You. "

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Editing a VERY VERY large CSV file

    I don't know that I have ever needed to edit that large of a text file, but I have liked Notepad++ (https://notepad-plus-plus.org/ ) as a text editor (but not word processor).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Editing a VERY VERY large CSV file

    Quote Originally Posted by MrShorty View Post
    I don't know that I have ever needed to edit that large of a text file, but I have liked Notepad++ (https://notepad-plus-plus.org/ ) as a text editor (but not word processor).
    Hi thanks for that link, however it reads in .CSV files but does not save as .CSV just about very ext but.

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Editing a VERY VERY large CSV file

    A CSV file is limited to 1,048,576 rows per column so are you saying the tab is filled from A1:GR1048576???
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Editing a VERY VERY large CSV file

    I did not have any difficulty saving a .csv file from Notepad++. A .csv file is a regular text file with the .csv extension. In Notepad++'s save as dialog, I simply chose the regular text file type and typed in the .csv extension.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Editing large amounts of data
    By CaitlinRose in forum Excel General
    Replies: 3
    Last Post: 02-05-2014, 02:49 PM
  2. [SOLVED] error message when editing a large spreadsheet
    By Quantech Industrial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  3. [SOLVED] error message when editing a large spreadsheet
    By Quantech Industrial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] error message when editing a large spreadsheet
    By Quantech Industrial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. error message when editing a large spreadsheet
    By Quantech Industrial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. error message when editing a large spreadsheet
    By Quantech Industrial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. error message when editing a large spreadsheet
    By Quantech Industrial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. error message when editing a large spreadsheet
    By Quantech Industrial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-09-2005, 05:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1